USE Liberty
GO
---------------------------------------------------------------------------------------------------
IF (SELECT OBJECT_ID('[ServiceMemberManagement].[GetAllTypesOfMilitaryBranch]')) IS NOT NULL
BEGIN
	DROP PROCEDURE [ServiceMemberManagement].[GetAllTypesOfMilitaryBranch] 
END
---------------------------------------------------------------------------------------------------

GO
CREATE PROCEDURE [ServiceMemberManagement].[GetAllTypesOfMilitaryBranch]

AS 

---------------------------------------------------------------------------------------------------
--						Liberty
---------------------------------------------------------------------------------------------------
--  Stored Procedure :: GetAllTypesOfMilitaryBranch
--                                                                            
---------------------------------------------------------------------------------------------------

SET NOCOUNT ON 

SELECT 	OID,
        Version,
		Branch as 'Description',
		Active,
		DisplayOrder,
		CreatedDate
FROM dbo.TypesOfMilitaryBranch
WHERE Active = 1        
ORDER BY DisplayOrder    

GO

---------------------------------------------------------------------------------------------------
-- Assign appropriate permissions
---------------------------------------------------------------------------------------------------
GRANT EXECUTE ON [ServiceMemberManagement].[GetAllTypesOfMilitaryBranch] TO [Liberty_Users]
GO

 